<html><head><title>complex constraint definition</title><meta name="HandheldFriendly" content="True"></head><body>Detailed syntax:<br><br>[<b>constraint</b> constraint] { { <b>unique</b> | <b>primary</b> <b>key</b> } [<b>clustered</b> | <b>nonclustered</b>] ({column [<b>asc</b> | <b>desc</b>]} <a href="w109049.html">(repeatable)</a> ) [<b>with</b> { <b>fillfactor</b> | <b>max_rows_per_page</b> } = value, [<b>reservepagegap</b> = value]] [<b>on</b> segment] | <b>foreign</b> <b>key</b> (column <a href="w109049.html">(repeatable)</a> ) <b>references</b>  [[database.]owner.]table [(column <a href="w109049.html">(repeatable)</a> )] [<b>match</b> <b>full</b>] | <b>check</b> (search_condition) ...}</body></html>